| Course: |
Accelerated Structured Query Language (SQL) Lab Crash Course
|
| Date: |
One Saturday, September 16, 2006, 9:00 AM - 5:00 PM
|
| CourseId: |
USQL2 |
| Location: |
Qualware Offices, Dennis Drive, Burlington, MA |
| Instructor: |
Jeffrey Goldberg, Qualware Instructional
Services |
| Provided Text: |
ISBN: 0672325675
After clicking, see book on last line.
If not found, use Alt
|
This lab course expands on the content of IEEE sponsored course of October 11, 2003.
Class Description:
This is an newly created, intensive, fast paced one day
mini-course covering everything one needs to understand and
use modern-day enterprise relational databases such as
Oracle and MySQL. After reviewing database fundamentals,
this course introduces the Structured Query Language (SQL)
and emphasizes its generic use in accessing modern-day
database engines from mutiple sources, such as command line
and scripted queries, programatic access from languages such
as Perl and C, to dynamic web page generation incorporating
information retrieved from the company databases. At least
half of the class will be devoted to lab exercises in SQL
and lab demonstrations. Since Unix platforms, rather than
Microsoft platforms, are typically the server of choice for
large scalable systems such as "eBay", this course will
also teach and demonstrate the use of these services from
the rarely taught Unix/Linux point of view using making use
of open source software whenever possible.
Prerequisite:
Some previous experience in any modern structural programming
or scripting language would be helpful but not required.
Targeted for:
Individuals that need to understand and/or use relational
databases in their upcoming projects, as well as those
individuals currently using SQL who need to advance their
abilities to include more complicated and efficient queries.
For those individuals interested in dynamic HTML web page
generation but not fluent in SQL, it is highly recommended
that you attend this course prior to signing up for the
"Dynamic Web Pages using PHP and Apache Server"
mini-course.
Course Objectives- What you will learn:
- Database Basics
- Learn All About the SQL Language
- Learn How to Create Tables inside a Database
- Details on the Select, Insert and Update Statements
- Learn How to Use Aggregate and General Purpose Functions
- Learn to Perform Relational Database Querries
Handouts:
Copies of the course outline slides will be provided along with
relevant handouts when appropriate.
Content Outline Summary:
Structured Query Language (SQL)
- Database Basics
- Database Data Types
- Fundamentals of SQL
- Retrieving Data: Select Statement
- Filtering Data: Where Clause
- Sorting Retrieved Data
- Wildcarding: Like Operator
- Calculated Fields
- Build-in Scalar Functions for Data Field Manipulation
- Aggregate Functions and Grouping Data
- SQL Language Divisions: DML, DCL, and DDL
- Creating Tables
- Understanding Constraints, Indexes
- Inserting Data: Insert Statement
- Updating Data: Update Statement
- Manipulating Tables
- Cross Table Joins
- Programatic and Dynamic Web Page Database Access
- Subqueries and Ways Around Subqueries
- Overview of Views, Stored Procedures, Parameterized Queries, Triggers
- Understanding Transaction Processing, Cursors when products like MS/VB
- Compare and Contrast Oracle with MySQL
- Demonstration of Integrating SQL in PHP Dynamic Web Pages.
- Database Security
For more info: email to jeffg@qualware.com
Add "not spam" to subject field.
Lecturer's biography:
An honor graduate of Tufts University, Jeffrey M. Goldberg
has served the engineering and academic community in various roles
from principal design engineer/project leader to senior consultant and
trainer at companies such as Hewlett Packard, Siemens,
Picturetel, 3Com, IBM, NMS, FST, IEEE, and EMC.
Mr. Goldberg is a long-time innovative user of UNIX and Internet services.
He currently develops and delivers public seminars and customized
corporate training classes along with very flexible scheduling,
to avoid project disruption, in the fields of IT operations,
operating system and computer languages. Specialties include
UNIX Fundamentals, Perl and Shell Scripting, C/C++ and Java,
Linux/Solaris/ UNIX System Administration and TCP/IP Networking,
Web Technologies such as Visual Basic, Delphi/Pascal, JavaScript,
PHP Apache /Tomcat, JSP/Servlets and SQL Database Access,
Computer and Network Security.
As a part time faculty of Worcester Polytechnic Institute and
Boston University, Mr. Goldberg is continually adding
new cutting-edge technology to his curriculum, and accepts
requests for customized on-site corporate training classes and tutoring.
For more information, please contact Mr. Goldberg at 781-229-1530 ext. 2
(Qualware), e-mail to
training2010@qualware.com
or visit
www.Qualware.com.
Besides operating Qualware Instructional Services, Mr. Goldberg is
also a principal of Qualware Consulting Group,
which performs a wide range of consulting services.
For more information, visit
http://www.qualware.com/qualware.
Copyright 2003-2010 Qualware Instructional Services and
Jeffrey Goldberg.
Course Fee Schedule:
REGISTRATION RECEIVED BY
Sep 4, 2006 |
REGISTRATION RECEIVED AFTER
Sep 4, 2006 |
|
$219 Special (normally $251) |
$313 |
Follow-on lab course exploring SQL advanced features, scheduled upon request.
|